<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Subtotals dialog box: Advanced tab</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { font-weight:normal; }
ul.whs2 { list-style:disc; }
p.whs3 { font-weight:bold; }
p.whs4 { font-weight:bold; margin-left:80px; }
p.whs5 { margin-left:80px; }
ul.whs6 { list-style:square; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nDisplaying and modifying grand totals and subtotals\nInterfaces for totals\nSubtotals dialog box: Advanced tab");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Subtotals Editor: Advanced tab</h1>
<p>Use the Advanced tab of the Subtotals Editor to specify whether each 
 metric subtotal is calculated by position on the report rows, columns, 
 and page-by fields, or across specific levels on the report. You can also 
 specify the level at which you want the subtotal to be calculated.</p>
<p class="whs1">From the drop-down list at the top of the 
 dialog box, specify the subtotal to be calculated by position or across 
 level.</p>
<ul type="disc" class="whs2">
	
<li class=p><p class="whs3">By position<span style="font-weight: normal;">: 
 Under the </span>Rows<span style="font-weight: normal;">, </span>Columns<span 
 style="font-weight: normal;">, or </span>Pages<span style="font-weight: normal;"> 
 (page-by fields) drop-down lists, select the subtotal to apply to that 
 part of the report. Each of these is considered an axis of the grid report. 
 For each drop-down list, select one of the following:</span></p></li>
	<ul type="disc" class="whs2">
		
<li style="list-style: square;" type=square class=p><p><span style="font-weight: bold;"><B>Rows 
 </B></span>and<span style="font-weight: bold;"><B> Columns</B></span>:</p></li>
		<ul type="disc" class="whs2">
			
<li style="list-style: circle;" type=circle class=p><p><span 
 style="font-weight: bold;"><B>All Subtotals</B></span>: Apply the subtotal across 
 all levels on the axis.</p></li>
			
<li style="list-style: circle;" type=circle class=p><p><span 
 style="font-weight: bold;"><B>Grand Total</B></span>: Apply only the subtotal 
 across the whole axis.</p></li>
			
<li style="list-style: circle;" type=circle class=p><p><span 
 style="font-weight: bold;"><B>None</B></span>: Apply the subtotal to no level 
 of the axis.</p></li>
		</ul>
		
<li style="list-style: square;" type=square class=p><p><span style="font-weight: bold;"><B>Pages</B></span>:</p></li>
	</ul>
	
<li style="list-style: circle;" type=circle class=p><p class="whs4">Selected 
 Subtotals<span style="font-weight: normal;">: Apply only selected subtotals 
 across the axis.</span></p></li>
	
<li style="list-style: circle;" type=circle class=p><p class="whs5"><span 
 style="font-weight: bold;"><B>Grand Total</B></span>: Apply only the subtotal 
 across the whole axis.</p></li>
	
<li style="list-style: circle;" type=circle class=p><p class="whs5"><span 
 style="font-weight: bold;"><B>None</B></span>:<span style="font-weight: bold;"> 
 <B></B></span>Apply the subtotal to no level of the axis.</p></li>
	
<li style="list-style: circle;" type=circle class=p><p class="whs5"><span 
 style="font-weight: bold;"><B>All Subtotals</B></span>:<span style="font-weight: bold;"> 
 <B></B></span>Apply the subtotal across all levels on the axis.</p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>Across level</B></span>:</p></li>
	<ul type="square" class="whs6">
		
<li class=p><p><span style="font-weight: bold;"><B>Select Levels</B></span>: 
 Apply the subtotal to all attributes available on the report. When you 
 select this, all attributes available in the report are listed for you 
 to choose from. Select those for which you want to calculate the subtotal. 
 </p></li>
	</ul>
</ul>
<h3>Related topics</h3>
<ul type="disc" class="whs2">
	
<li class=p><p>
<a href="Display_and_hide_totals.htm">Showing or hiding 
 all totals</a></p></li>
	
<li class=p><p>
<a href="Removing_totals.htm">Removing totals</a></p></li>
	
<li class=p><p>
<a HREF="Subtotals_dialog_Definition.htm">Subtotals 
 dialog box: Definition tab</a></p></li>
	
<li class=p><p>
<a href="Subtotals_dialog_Display.htm">Subtotals dialog 
 box: Display tab</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
